Prerequisites

Before you can use Snowflake as a data warehouse in a Qlik Compose project, make sure that the following prerequisites have been met:

Client

• Download and install Snowflake ODBC driver for Windows 2.18.1 or later.

• The Qlik Compose machine must be set to the correct time (UTC).

Permissions

The user specified in the Snowflake data warehouse settings must be associated with a role that grants the following privileges:

• USAGE on the Snowflake warehouse
• USAGE or OWNERSHIP on the specified database and its schemas
• SELECT on the INFORMATION_SCHEMA schemas

• CREATE SCHEMA on the specified database.

  Information note

  Only required for user-specified schemas that do not yet exist on the target.

• Tables:
• CREATE
• SELECT
• INSERT
• UPDATE
• DELETE
• TRUNCATE
• REFERENCES (for current and future tables)
• DROP (for user-initiated Drop and Create operations)
• Views:
• SELECT
• CREATE (for current and future views)
• DROP (for user-initiated Drop and Create operations)
• External functions called by user-defined ETLs:
• USAGE